
<cfquery name="createUsers" datasource="default">
drop table if exists test; 
create table test(id int identity, name varchar(255), type varchar(100) default 'test', email varchar(100) default NULL); 
insert into test(name) values('Hello'); 
insert into test(name) values('Hello'); 
insert into test(name) values('Hello'); 
insert into test(name) values('Hello'); 
insert into test(name) values('World');  
</cfquery>

<cfquery name="test" result="getTest" datasource="default">
select * from test;
</cfquery>



<cfdump var="#test#">
<cfdump var="#getTest#">
<cfdump var="#getTest.sql#">
<cfdump var="#test.recordCount#">